#-*- coding:utf-8 –*-
import pymysql
import pandas as pd
from pandas import Series,DataFrame

print "读取数据库数据".decode('utf-8').encode('cp936')

con = pymysql.connect(host="127.0.0.1",user="root",password="root",db="test",charset="utf8")
data_sql=pd.read_sql("select * from user_info",con)
print(data_sql)